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

86 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
escalop114478(None) 
escallop1243191escallop
escalope1244521escalope
escalops1244671escalops
escallops1343192escallops
escaloped1443982escaloped
escalopes1344772escalopes
escarp10449002esca_rp
eschalot1346212eschalot
scallop11237642_scallop
scalp95217982_scal_p
calo64936443__calo_
calos74431903__calos
clop86929893__c_lop
decalog1136003decalog
encamp1235943enca_mp
enclasp1145843enclasp
enhalo987563enhalo_
enhalos1087533enhalos
envelop1243323envelop
escalade1144383escalade
escalate1039323escalate
escalator1145683escalator
escalloped1542593escalloped
escaloping1543723escaloping
escape103811663esca_pe
escaped12388853escaped
escapee113310463escapee
escaper11368843escaper
escapes113811673escapes
escar74011993esca__r
escargot1183863escargot
escarole1045743escarole
escarps11397373escarps
escars83913133esca_rs
eschalots1444133eschalots
escolar946053escolar
escot75320083esc__ot
escrow1135913esc_row
escudo943373escudo_
escudos1043493escudos
espanol943783espanol
estop74312103es__top
etalon648973e_talon
eucalypt1552813eucalypt
galop84716223__galop
jalop144212603__jalop
mescal104113483mescal__
mescals112911553mescal_s
rescale93215473rescal_e
rescaled113311303rescaled
rescales103414573rescales
salep77022953_s_alep
salol55222143_s_alol
salon55228553_s_alon
saloop84212583_s_aloop
salp64534093_s_al_p
scalar83612433_scalar
scald84818123_scal_d
scalds94813693_scalds
scale74629143_scal_e
scaled94822443_scaled
scaler84321603_scaler
scales84529313_scales
scaleup1134483_scaleup
scall74420373_scal_l
scallops12297393_scallops
scalls84218203_scalls
scalps104315233_scalps
scaly104718723_scal_y
scamp115717313_sca_mp
scarp95724103_sca_rp
scaup95515993_sca_up
schlep1347093_schlep
scollop11275433_scollop
scoop95617163_sc_oop
scop85925523_sc__op
scroop10299783_scroop
sculp95314843_scul_p
secalose1046963secalose
shallop12348453_shallop
shalom11810923_shalom
slalom888173_slalom
slop66533873_s__lop
zocalo1735803zocalo_
zocalos1835393zocalos

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 Filter1786911340270.390458182.1
2DLD Change Limit134027866.95619267.8
3Display Results86860.0302866.7
 (SQL Overall)178691867.37624226.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.