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 “yarnt” with Change Limit: [1] [2] [3]

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

78 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
yarn75230041yarn_
yarns85621791yarns
ant37270792_a_nt
art38679142_ar_t
aunt46553652_aunt
barn66444642barn_
barns76335142barns
barny105821732barny
brant74742172brant
burnt75230332burnt
cant66362032ca_nt
carat75048802carat
caret75360562caret
carn66245432carn_
carnet84732872carnet
carns75937562carns
carny105822922carny
cart66570342car_t
darn56434622darn_
darns66927892darns
dart55857872dar_t
daunt65929082daunt
earn46737552earn_
earns55927562earns
faint85837062faint
fart76860562far_t
garnet73928412garnet
garni6315702garni
gaunt65430402gaunt
grant64840022grant
haint85436322haint
hant75461592ha_nt
hart76865772har_t
haunt85229132haunt
jaunt125025272jaunt
karat96837612karat
karn86129432karn_
karns96624152karns
karst97229002karst
kart86750822kar_t
learnt64019252learnt
lyart85121882lyar_t
mart66865982mar_t
paint75443692paint
pant66061262pa_nt
parent83230422parent
part65967462par_t
rant45864682ra_nt
saint55147072saint
taint55542282taint
tarn46842722tarn_
tarns56433952tarns
tarot55943932tarot
tart47566182tar_t
taunt55532282taunt
tyrant9315332tyrant
varna84516182varna
vaunt85925312vaunt
want76156172wa_nt
warn75239322warn_
warns87231002warns
wart77866082war_t
yacht13417392yacht
yang85626082ya_ng
yank115423672ya_nk
yar67253832yar__
yard85633252yar_d
yards95324612yards
yare75636942yar_e
yarer84321572yarer
yarest95018912yarest
yarned105514022yarned
yarner93313062yarner
yawn106219092yawn_
yawns114213272yawns
yearn86316432yearn_
yearns9509542yearns
yurt76435042yur_t

Search took 3 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 Filter178691538000.310576422.6
2DLD Change Limit53800782.11025497.6
3Display Results78780.0461695.7
 (SQL Overall)178691782.46672461.9
 
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.