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

83 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
flauntier124306(None) 
flaunter1135011flaunt_er
faultier1135282f_aultier
flaunted1234602flaunt_ed
flaunters1234512flaunt_ers
flauntiest1343772flauntiest
flauntily1542652flauntily
flaunting1335042flaunting
flintier1136392fl_intier
flouncier1442482flouncier
flutier103011552fl_u_tier
jauntier1535232_jauntier
auntie64317703__auntie_
aunties73920073__aunties
auntlier834903__auntlier
blastier10249493bla_stier
blunter94512033bl_unt_er
chaunter1366393chaunt_er
clankier14327083cla_nkier
clunkier14345793cl_unkier
daintier937403_daintier
daunter83811753_daunt_er
fainter103611053f_aint_er
fancier123412063f_a_ncier
fattier103513463f_a_ttier
fawnier13296363f_awn_ier
flabbier1534093fla_bbier
flaggier13105203fla_ggier
flakier143910203fla__kier
flamier123112143fla__mier
flanger113412623fla_n_ger
flanker143911293fla_n_ker
flappier1544293fla_ppier
flashier1437103fla_shier
flatter103815963fla__tter
flaunt9712913flaunt___
flaunts1056133flaunt__s
flaunty1354413flaunt__y
flautist1186803flau_tist
flawier13378733fla__wier
flaxier17337983fla__xier
flightier1644423flightier
flirtier1144893fl_irtier
floatier1136983fl_oatier
flounder1235103floun_der
flouter104311343flou_t_er
fluffier13264333fl_uffier
flukier14397853fl_u_kier
flunker14389363fl_un_ker
flunkie1434513fl_unkie_
flunkies1536393fl_unkies
fluster103913063fl_ust_er
fluter95316863fl_u_t_er
flutter104012093fl_u_tter
flytier13356503fl__ytier
frontier1147313f_rontier
fruitier1136593f_ruitier
funkier14349983f__unkier
funnier103210173f__unnier
fustier104213933f__ustier
gaunter82910713_gaunt_er
glintier945703gl_intier
haunter103111153_haunt_er
lankier113711633_la_nkier
launcher1365563_launcher
launder8309143_laun_der
lintier73613803_l_intier
lunier64617603_l_un_ier
lustier73813503_l_ustier
paintier1048793_paintier
planter94017803pla_nt_er
platier93716293pla__tier
plunkier14305323pl_unkier
runtier73512853__runtier
saunter72913453_saunt_er
scantier10309983sca_ntier
slangier9117933sla_ngier
slatier74016813sla__tier
sluttier836453sl_uttier
taunter73111453_taunt_er
vaultier1144293_vaultier
vaunter10309603_vaunt_er
vauntie1036633_vauntie_

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 Filter1786911486410.423422437.4
2DLD Change Limit148641836.96621338.1
3Display Results83830.0332515.2
 (SQL Overall)178691837.42224075.9
 
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.