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

107 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
rectrices133887(None) 
tectrices1346251tectrices
directrices1652892directrices
gentrices1258912gentrices
rectories11314642rectori_es
reprices122913352re_prices
restricts1138822restricts
restrikes1339412restrikes
restrives12310662restrives
retraces101417272re_traces
retries74129072re_tri_es
becrimes1467073bec_rimes
bestrides1237913bestrides
bisectrices1752313bisectrices
carices114220953__carices
cicatrices1343493cicatrices
decries103319803dec_ri_es
decuries11312223decuri_es
dextrines1798313dextrines
directrice1552803directrice_
directrixes2152063directrixes
doctrines1247153doctrines
editrices1245323editrices
electrics1348003electric_s
entices91616333_ent_ices
entries71523163_entri_es
executrices2251903executrices
gentrice1148813gentrice_
gentries91315263gentri_es
heretrices1546303heretrices
heritrices1555303heritrices
licorices1346353licorices
matrices12312083_matrices
metrics11312363me_tric_s
nectaries1149813nectari_es
nectarines1246893nectarines
oratrices1145833oratrices
pectines121914683pect_ines
pectizes21229793pect_izes
peltries10313023peltri_es
practices1557993pract_ices
precipices1845513precipices
prentices131111903prent_ices
preprices1569263pre_prices
reactances1446143reactances
reburies10311143reburi_es
recarries1147863recarries
recces10614913rec___ces
receives1339743rec_eives
recencies13312253recencies
recipes113314463rec__ipes
recircles1344433recircles
recites93524583rec__ites
reclines103718543rec_lines
recopies12313733recopi_es
recrates102420373rec_rates
rectifies14310813rectifies
rectorates12410363rectorates
rectrix1645363rectri__x
recurves1337403recur_ves
redbricks1842303redbricks
redries83721713re_dri_es
redrives122610393re_drives
reentries9311763reentri_es
refries104419733re_fri_es
rejoices17287663re_joices
reprice113212833re_price_
repriced132610543re_priced
reprises102615463re_prises
reptiles103913063rept_iles
rerises73525883re__rises
reservices1544893reservices
resplices1336623resplices
restricken1643793restricken
restrict10313633restric_t
restricted1348303restricted
restrike1239673restrike_
restrings10159293restrings
restrive11310923restrive_
restriven1246233restriven
reticles103912483re_t_icles
reties65436193re_t_i_es
retiles74426993re_t_iles
retimes95020173re_t_imes
retines75134673re_t_ines
retirees84611653re_tirees
retires74726213re_t_ires
retrace91417343re_trace_
retraced111413023re_traced
retracer101411883re_tracer
retracers11149553re_tracers
retracks14149103re_tracks
retracts101111313re_tracts
retrials8510823re_trials
retried84419153re_tri_ed
retrieves1265653re_trieves
retrims93612373re_tri_ms
reveries112518513reveri_es
revoices13278993re_voices
rewrites11311063re_writes
sectaries11312243sectari_es
sentries81318053sentri_es
tectites1039993tect_ites
trices84826333___trices
ventricles1544523ventricles
vertices13612283vert_ices
vestries11314053vestri_es

Search took 10 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.470380193.6
2DLD Change Limit1486411078.64017203.8
3Display Results1071070.0462326.1
 (SQL Overall)1786911079.15619516.3
 
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.