Welcome!   |  Search Scrabble® Dictionary using DLD   |  Statistics   |  Compare any two Strings using DLD   |  Reference   |  Your IP

Dictionary Search Results using Damerau-Levenshtein distance in T-SQL

Here are the results of your fuzzy-string dictionary search for “sherrises” with Change Limit: [1] [2] [3] [4]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

98 similar words found! Changes to Transform each Found Word to your word are shown as:
 remove a letter ~ replace a letter ~ swap two letters ~ _add a letter from your word
(Use the links in the Changes column to see more Transformation details.)

Found WordScrabble ScoreSearched PreviouslyFound PreviouslyChangesTo Transform to your Word
sherrises1215686(None) 
sherries111812891sherri_es
cherries131812982cherri_es
derrises93012782_derrises
herries104025072_herri_es
serries73925352s_erri_es
sherris10168802sherri__s
skerries12168672skerri_es
theorises1247812theorises
wherries14179022wherri_es
arrises71617583__arrises
berries94423553_berri_es
cercises12410933_cercises
cerises94722253_ce_rises
chemises153211983che_mises
cherishes1767563che_rishes
dermises112512023_dermises
derries83124623_derri_es
dhurries1255583dhurri_es
energises1047063energises
eternises9119453eternises
exercises1846463exercises
ferries103521083_ferri_es
ferrites112312833_ferrites
gharries12318203gharri_es
harries103525493_harri_es
hearses104414533_hear_ses
henries102718283_henri_es
heresies11312693_heresies
heroines112916573_heroines
heroisms1338693_heroisms
heroizes202610983_heroizes
herried113514453_herri_ed
herrings12379533_herrings
hubrises1337103_hubrises
hurries103919653_hurri_es
hybrises1645423_hybrises
jerries143817513_jerri_es
kermises14248313_kermises
kerries113317913_kerri_es
merises93421423_me_rises
morrises10711073_morrises
orrises71312233__orrises
overrides131411013overrides
perries93226603_perri_es
phereses1348093phe_reses
reprises102615463_reprises
reraises8415643_reraises
rerises73525883_re_rises
satirises9410193satirises
scurries102911483scurri_es
seeresses939053seeresses
seises64026713s_e__ises
semises93916553s_e_mises
series64540973s_e_ri_es
serines74229543s_e_rines
serrates82617023s_errates
serried82513963s_erri_ed
services1338573s_ervices
sharpies13411223sharpi_es
shearings13337563shearings
sheenies111411543sheeni_es
sheerness1236273sheerness
shelties111111383shelti_es
sheriffs17253923she_riffs
sherifs13299683she_ri_fs
shirrings13245323shirrings
shorties11414583shorti_es
shrikes144412393sh__rikes
shrines104618693sh__rines
shrives134416173sh__rives
skepsises1542753skepsises
slurries82710413slurri_es
solarises9512703solarises
speises93813933spe__ises
spermines13310543spermines
spurries102311323spurri_es
stearines9311283stearines
sterilises1048253sterilises
sternites9310073sternites
suberises11813453suberises
sunrises8310693s_unrises
supervises1549073supervises
surmises10310643s_urmises
surprises1137433surprises
terrases82111483_terrases
terries73425633_terri_es
terrines82117553_terrines
theories11311593theori_es
theorise1137873theorise_
theorised1344923theorised
theorists1246603theorists
theorizes2147073theorizes
thermites1438043thermites
thermoses1447973thermoses
whereases1545673whereases
wherried15175013wherri_ed
whirries14136693whirri_es

Search took 8 seconds overall (including website activity, plus SQL activity in the following phases):

  1. Length Filter: Limit the application of DLD to words with length difference of no more than the Change Limit.
  2. DLD Change Limit: Apply DLD to each remaining word, limiting each comparison according to the Change Limit.
  3. Display Results: Return the results, with similar words marked up to highlight differences.
SeqSearch PhaseWords CheckedWords MatchedSecondsWords Per Sec
1Length Filter1786911486410.423422437.4
2DLD Change Limit148641986.89021573.4
3Display Results98980.0462130.4
 (SQL Overall)178691987.35924282.0
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2025  |  Published At: SQLServerCentral (with Source Code)  |  Presented At: SQLSaturday #144  |  Demonstrated For: Sacramento SQL Server User Group  |  Developed For: Repo Remarketing  |  Running On: Microsoft SQL 2014 RTM Standard on Server 2012 R2 (also successfully run on SQL 2012 Web Edition, SQL Express 2008-2008R2, and SQL Server 2000-2005 Standard)  |  SQL Performance Monitoring By: Confio Ignite  |  American Scrabble® Dictionary From: Internet Scrabble Club  |  Scrabble® is a registered trademark. All intellectual property rights in and to the game are owned in the U.S.A and Canada by Hasbro Inc., and throughout the rest of the world by J.W. Spear & Sons Limited of Maidenhead, Berkshire, England, a subsidiary of Mattel Inc. Mattel and Spear are not affiliated with Hasbro. This site is not affiliated with Scrabble®, Mattel, Spear, or Hasbro in any way. This site is for entertainment and technical education purposes only.