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 “diverters” with Change Limit: [1] [2] [3]

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

114 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
diverters1322787(None) 
diverter12238621diverter_
averters11249512_averters
deserters10129982deserters
diesters92513602di_esters
dieters83216432di_e_ters
digesters11257882digesters
dimeters11411092dime_ters
diverges13258312diverge_s
diverted13199582diverte_d
diverts114412032divert__s
divorcers1543692divorcers
inverters12239752inverters
reverters122710432reverters
riveters11228162rive_ters
asserters956383asserters
averter102410553_averter_
bimesters1336343bimesters
cavorters1434973cavorters
converters1539633converters
coverers132712123cover_ers
coveters132411083cove_ters
darters84017603d__arters
decenters122410373decenters
defeaters13289103defeaters
deferrers13115153deferrers
deliverers1443663deliver_ers
demergers13146403demergers
deporters1277793deporters
deserter91211603deserter_
deservers13107293deservers
detecters12217753detecters
detergers11147183detergers
deterrers10116593deterrers
deters74724683d__e_ters
detesters10298303detesters
diameters1247593diameters
diasters92913183di_asters
diester83013683di_ester_
dieter73516773di_e_ter_
diethers1257453di_ethers
digester10258433digester_
digestors11257273digestors
dilaters92513063di_laters
diluters9288113di_luters
dimeter10411893dime_ter_
dinettes9310193dinette_s
diopters1137693di_opters
directer1137583directer_
directors1248133directors
disarmers1246943disarmers
disasters1039153disasters
discerners1345703discerners
disinters1039713disinters
disorders1146953disorders
dispersers13137423dispersers
disputers1236613disputers
dissenters1197723dissenters
distorters1147163distorters
ditherers13196683dither_ers
diverge12347643diverge__
diverged14256883diverge_d
divergent1447363divergent
divers105024963div___ers
diverse11429993diverse__
diversely1643963diversely
divert103922813divert___
diverting142410333diverting
divested13268213diveste_d
divests114510933divest__s
divesture13144183divesture
divestures14144253divestures
dividers13257213div_iders
diviners12308353div_iners
divorcees1543333divorcees
divorcer1444033divorcer_
divorces1445673divorce_s
divulgers1442433divulgers
dopesters1237283dopesters
drivelers1364223drive_lers
drivellers1452953drivellers
driverless1452703driverless
evertors1138953_evertors
figeaters1345753figeaters
hoverers14289023hover_ers
inserters92210283inserters
inventers12269533inventers
inverter112411073inverter_
invertors12239783invertors
kiesters123310153ki_esters
liveners11217933live_ners
liveries11314373liverie_s
misenters1139533misenters
miterers10219683miter_ers
perverters1544953perverters
piercers12316723pi_ercers
quiverers2143713quiver_ers
reverers113113153rever_ers
reversers12298483reversers
reverter114812873reverter_
rimesters1137483rimesters
riverbeds15243073riverbeds
riverless1244943riverless
riveter10208753rive_ter_
shiverers15155773shiver_ers
silverers12215753silver_ers
sliverers12196363sliver_ers
subverters1544613subverters
taverners1244273taverners
venters103717733__venters
vergers114412633__vergers
versers103813523__versers
vetters104016323__vetters
waverers14318613waver_ers

Search took 9 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.203880251.2
2DLD Change Limit1486411147.76619140.0
3Display Results1141140.0462478.3
 (SQL Overall)1786911148.01522294.6
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.