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

80 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
escalops124467(None) 
escallops1343191escallops
escalop1144781escalop_
escalope1244521escalope
escalopes1344771escalopes
escallop1243192escallop_
escaloped1443982escaloped
escarps11397372esca_rps
eschalots1444132eschalots
scallops12297392_scallops
scalps104315232_scal_ps
calos74431903__calo_s
clops95924853__c_lops
cyclops1635383cyc_lops
decalogs1245633decalogs
encamps1335423enca_mps
enclasps1245133enclasps
enhaloes1197343enhaloes
enhalos1087533enhalo_s
envelops1343493envelops
escalade1144383escalade
escalades1244403escalades
escalate1039323escalate
escalates1148823escalates
escalators1245303escalators
escalloped1542593escalloped
escaloping1543723escaloping
escape103811663esca__pe
escapees12336333escapees
escapers12337413escapers
escapes113811673esca_pes
escargots1262263escargots
escarole1045753escarole
escaroles1145283escaroles
escarp10449003esca_rp_
escars83913133esca__rs
eschalot1346223eschalo_t
escolars1045343escolars
escots84211743esc__ots
escrows1235803esc_rows
escudos1043493escudo_s
estops84011223es__tops
etalons739073e_talons
eucalypt1552813eucalypt
eucalypts1651873eucalypts
galops94712623__galops
jalops15329593__jalops
megalops1356123megalops
mescals112911573mescal__s
rescales103414573rescal_es
saleps85014903_s_aleps
salols64017873_s_alols
salons63823693_s_alons
saloops93510133_s_aloops
salps74423243_s_al_ps
scalars93711913_scalars
scalds94813693_scal_ds
scalers93817263_scalers
scales84529313_scal_es
scaleups1243393_scaleups
scallop11237643_scallop_
scalls84218203_scal_ls
scalp95217983_scal_p_
scamps125014173_sca_mps
scarps104718603_sca_rps
scaups105411933_sca_ups
schleps1445483_schleps
scollops12235703_scollops
scoops105414363_sc_oops
scops95820193_sc__ops
scroops11288253_scroops
sculps104611753_scul_ps
secalose1046963secalose
secaloses1146913secaloses
sepalous1047523sepalous
shallops13288323_shallops
shaloms1288983_shaloms
slaloms9106543_slaloms
slops75026013_s__lops
zocalos1835393zocalo_s

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 Filter1786911461620.423422437.4
2DLD Change Limit146162807.39019778.3
3Display Results80800.0302666.7
 (SQL Overall)178691807.84322783.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.