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

117 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
tailfins113544(None) 
tailfans1144551tailfans
tailfin1035691tailfin_
tailfan1044652tailfan_
tailing82923102tail_ing
tailings93211672tail_ings
tailspins1143622tailspins
tailwind1243472tailwind
tailwinds1342352tailwinds
tiffins13327982t_iffins
ablins8316193_abl_ins
aiblins9311473_aiblins
ailing74331013_ail_ing
algins74816433_a_lgins
aloins65022203_a_loins
anilins7416793anil_ins
bailies94120203bail_ies
bailiffs1642563bailiffs
bailing103723523bail_ing
biffins15358533_biffins
calkins133814873ca_lkins
caplins113515993capl_ins
carlins93921923carl_ins
catlins93818843catl_ins
dailies84219263dail_ies
elfins94810943__elfins
failing113521333fail_ing
failings123811013fail_ings
galleins9258693galleins
griffins1544783griffins
hailing113820693hail_ing
hairpins1365433hairpins
jailing153415843jail_ing
kaolins1139363kaol_ins
mailing102923343mail_ing
mailings113011923mail_ings
malkins133311803ma_lkins
marlins93420473marl_ins
nailing83419963nail_ing
pailfuls1343843pailfuls
paulins9312613paul_ins
railing83325643rail_ing
railings93412153rail_ings
raisins72715343rai_sins
ratlins73615583ratl_ins
sailfish1446053sailfish
sailing83927373sail_ing
sailings93513253sail_ings
saimins9312113sai_mins
sainfoins1243813sainfoins
salicins10310933salicins
salifies11314793salifies
tabling103216033tabl_ing
tabloids1146163tabloids
taborins103310223taborins
taffias13377413ta_ffias
taffies133012693ta_ffies
tafias93111963ta__fias
tagline82412453tagl_ine
taglines92210833tagl_ines
tailbone1045493tailbone
tailbones1155263tailbones
tailers73720183tail_ers
tailles72516473tail_les
tailless8239083tailless
taillike1237863taillike
tailoring1036403tailoring
tailorings1143433tailorings
tailors73212393tail_ors
tailpipe1253003tailpipe
tailpipes1373073tailpipes
tails55634193tail___s
tailskids1442053tailskids
tailspin1043763tailspin_
tains54936323ta___ins
tainting93613583tainting
taipans9269553tai_pans
takins105117403ta__kins
talcing103111633ta_lcing
talions7314113ta_lions
talkies113415733ta_lkies
talking123815823ta_lking
talkings13358403ta_lkings
tallies73624603ta_llies
tallis63319963ta_lli_s
tallits73215993ta_llits
tallying12318833tallying
talons64019443ta_l_ons
tamarins10310843tamarins
tameins9311423ta_meins
tannins72813223ta_nnins
tariffing1644113tariffing
thiamins1346633thiamins
thiazins2045313thiazins
thionins1177923thionins
tiepins939463t_iepins
tiffin12327933t_iffin_
tiffing14339383t_iffing
tiling73426553t_il_ing
tilings84212793t_il_ings
tilling83522783t_illing
tilting83417103t_ilting
toiling83219023toil_ing
tolidins948023tolidins
trailing92916093trail_ing
triazins1738353triazins
trifling122411503trifling
triflings13235973triflings
trilbies1037693trilbies
trilling92815963trilling
trillions947183trillions
twilling12268673twilling
twillings13234913twillings
vailing113817953vail_ing
vanillins1245553vanillins
waifing142910893wai_fing
wailing113620903wail_ing

Search took 9 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.420425454.8
2DLD Change Limit1461621178.37617450.1
3Display Results1171170.0462543.5
 (SQL Overall)1786911178.84220209.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.