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 “residents” 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.

108 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
residents103842(None) 
presidents1347021presidents
resident9313751resident_
coresidents1484272coresidents
president12410992president_
regiments123910322regiments
resents74221222res__ents
residence1268902residence
residences1368232residences
residency1565512residency
residers93311882reside_rs
resides84523282reside__s
rewidens1235532rewiden_s
accidents14155133accidents
besides104814533beside__s
copresidents1762843copresidents
coresident1376793coresident_
crescents1367543cres_cents
decadents1346393decadents
decedents1347323decedents
descents112511203des_cents
desinent9312963desinent_
dissidents1245023dissidents
evident1139993_evident_
incidents1246803incidents
nescients1145103nescients
nonresidents1354273nonresidents
occidents14103833occidents
pediments1448343pediments
pendents1139413pe_ndents
penitents1147703penitents
precedents1545723precedents
presents103315643pres__ents
presidency1844653presidency
presiders1248213preside_rs
presides11414913preside__s
raiments1039903r_aiments
reaccents1365853reaccents
reagents959623re_agents
reascents1177403reascents
recements13312283recements
recipients1444893recipients
reddens9259783re_dden_s
redigests1154683redigests
redirects12125103redirects
referents12259643referents
regents83416543re__gents
regimens11469233regimen_s
regiment114414053regiment_
reinvents1246123reinvents
relents74018503re__lents
remints95117293remi__nts
remitments1446843remitments
renitent8315333renitent_
reorients997363reorients
repents93717623re__pents
repigments1546343repigments
rerents73319423re__rents
rescindments1752793rescindments
reseats74319583res__eats
resects94115593res__ects
reselects1156413reselects
resends83513713res__ends
resent63833623res__ent_
resets65427613res__e_ts
reside74224933reside___
resided95217703reside__d
residencies1445973residencies
residential1255273residential
resider84615803reside__r
residing103015473residin_g
resids74219153resid___s
residuals10223803residuals
residues9338813resid_ues
residuums1251903residuums
resifts10378703resi__fts
resights1246733resi_ghts
resigners1036863resigners
resigns83910963resi_gn_s
resiles74026543resile__s
resilient9410113resilient_
resilins83013373resilin_s
resins64528773resi__n_s
resistants1045523resistants
resists74414923resi__sts
resites74027793resite__s
resits64725563resi___ts
resizes164216843resize__s
resmelts1046143res_melts
resojets1535343resoje_ts
resolvents1344343resolvents
resonants946693resonants
respects1247703res_pects
respondents1454273respondents
reticent10313293reticent_
retinenes9410373retinenes
retints74717013reti__nts
retirants947323retirants
rewiden1137533rewiden__
rewidened1444073rewidened
rident7520193r__ident_
rodents8611543r__odents
rudiments1245823rudiments
sediments1248213sediments
silents73514493__silents
tridents938583_tridents
vesicants1444753vesicants
vestments1486813vestments

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.1561145455.1
2DLD Change Limit1486411086.92321470.6
3Display Results1081080.0462347.8
 (SQL Overall)1786911087.12525079.4
 
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.