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 “flautist” 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
flautist118680(None) 
flautists1253681flautists
flutist102910781fl_utist
autist64324942__autist
fauvist1336662f_auvist
flattest1138712flattest
flattish1455262flattish
flauntiest1343772flauntiest
flautas1036152flautas_
flutiest112610882fl_utiest
flutists11256412fl_utists
lutist64317552_l_utist
alarmist1049123alarmist
artist64125543__artist
aurist65027253__aurist
autism83815333__autism
autists73814853__autists
baptist11311873_baptist
blastiest111710043blastiest
chartist131112133chartist
chutist1239453_chutist
cladist10311973cla_dist
classist104010383classist
elitist7414913el_itist
etatist7415033eta_tist
fabulist1347673fabulist
faddist12289643f_addist
fantast10311703f_antast
fascist1239213f_ascist
fastest102413723f_astest
fattest102913063f_attest
fattiest113514313f_attiest
fattish1359263f_attish
faultiest1236093f_aultiest
fauvism1545223f_auvism
fauvists1443843f_auvists
featest102715113fea_test
feudist1137573f_eudist
flabbiest1644203flabbiest
flaggiest14145503flaggiest
flakiest153210543flakiest
flamiest133111973flamiest
flappiest1644853flappiest
flashiest1557983flashiest
flatfish1744933flatfish
flatlet10312253fla_tlet
flats86429743fla_t_s_
flatting123511253flatting
flatus94310783fla_tus_
flatwise1443973flatwise
flaunt9712913flau__nt
flauntier1243063flauntier
flauntily1542653flauntily
flaunting1335043flaunting
flaunts1056133flaunts_
flauta937823flaut__a
flavorist1545453flavorist
flawiest14298573flawiest
flaxiest18298183flaxiest
fleetest1136723fleetest
flintiest1248433flintiest
flirtiest1236193flirtiest
floatiest1237283floatiest
florist10314243fl_orist
flourish1446753flourish
flouting122610473flouting
flouts94315273flout_s_
fluish1239333fl_u_ish
flukiest15248063fl_ukiest
flutes95421783fl_utes_
flutier103011553fl_utier
fluting113815093fl_uting
fuguist1136073fugu_ist
futurist1148283futurist
latest63822703_la_test
latish92416173_la_tish
leftist10279353_leftist
loutish1039963_loutish
lutists73810273_l_utists
platiest103216083pla_tiest
plaudit1046253plaudi_t
plaudits1144263plaudits
playlist1347573playlist
slatiest82616263sla_tiest
statist7317723sta_tist
tautest72612443_tautest

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.403443402.0
2DLD Change Limit146162867.16020413.7
3Display Results86860.0302866.7
 (SQL Overall)178691867.59323533.6
 
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.