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

52 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
eclair836811eclair_
eclairs935961eclairs
eclat7523602ecla__t
airt45757793___airt
caird85717233_c_aird
cairn75717513_c_airn
cart66570343_c_a_rt
cellist9314423cellist
chair105519633_chair_
chairs114916183_chairs
chart105038283_cha_rt
cladist10311973_cladist
claim95616913_clai_m
claims105211573_claims
clapt98027173_cla_pt
claret84026573_claret
clarity12310913_clarity
claro75018693_cla_ro
clary105719613_cla_ry
claspt104513413_claspt
clast76030583_cla_st
clift106422193_cl_ift
clipt96324273_cl_ipt
declaim1247363declai_m
declaims1345823declaims
declare10411233decla_re
ecarte84313503ec_a_rte
echard1249223echa_rd
eclats8313033ecla_ts
elain55324703e_lai_n
elains64919853e_lains
elint55436473e_l_int
engirt71112613e_ngirt
enlist6417043enl_ist
exclaim1844943exclai_m
exclaims1943943exclaims
flair86114123_flair_
flairs95711913_flairs
flirt87424753_fl_irt
glair65313553_glair_
glaire74411303_glaire
glairs75211333_glairs
glairy10448273_glairy
lair45934153__lair_
laird65417793__laird
lairs55425873__lairs
plaint85323203_plaint
plait75631573_plai_t
rechart12314343recha_rt
reclaim1137753reclai_m
reclaims1236113reclaims
scart76139773sc_a_rt

Search took 7 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.423422437.4
2DLD Change Limit134027526.03022226.7
3Display Results52520.0163250.0
 (SQL Overall)178691526.46927622.7
 
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.