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

97 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
twibils125311(None) 
twibil1133561twibil_
twibill1242741twibill
twibills1342321twibills
tibias839952t_ibias
tribals9610752tribals
twills9489792twi_lls
twirls9478122twi_rls
alibies9313323alibies
alibis8311073alibi_s
bulbils11338333bulbils
cibols1039523_cibols
fibrils1236843_fibrils
gerbils1037303gerbils
ghiblis1353343ghiblis
huipils1243533huipils
ibis66519583__ibi_s
libels85112693_libels
nihils937573_nihils
oribis838833oribi_s
pibals103813083_pibals
sibyls1135303_sibyls
sigils73912363_sigils
strigils946853strigils
strobils1046563strobils
swails94913123sw_ails
swills94213363swi_lls
swirls94010133swi_rls
swivels13396773swivels
tabbies112913503tabbies
tabbis102910863tabbi_s
tahsils1035053tahsils
tails55634193t__ails
teiids736693tei_ids
tenails73713923tenails
terbias9310743terbias
thills95515383thi_lls
thiols95112763thi_ols
thirls95012063thi_rls
tibia7312403t_ibi_a
tibiae838483t_ibiae
tibial849843t_ibial
ticals83214713t_icals
tidbits1035183tidbits
tidies74721833t_idies
tidily102811393t_idily
tikis95615973t_iki_s
tills54631713t_i_lls
tils45739613t___ils
timbals11239533timbals
tinily94014433t_inily
tipis76019923t_ipi_s
tirls54519803t_i_rls
titbits935803titbits
titis56023813t_iti_s
tobies84521023t_obies
toils54527493t__oils
tonsils7310183tonsils
trails64622513t_rails
trials64319883tri_als
tribal8611133tribal_
tribes85119023trib_es
trilbies1037693trilbies
trills64319853tri_lls
triols66117803tri_ols
tumbrils12255373tumbrils
turbits969233turbits
twains95811183tw_ains
twiddle12305483twiddle
twiddles13265613twiddles
twiddly15233773twiddly
twiers95410163twi_ers
twigs96911173tw__igs
twilit949553twili_t
twill85612723tw__ill
twiners10459633twiners
twines94717273twi_nes
twinges11409453twinges
twinier1037313twinier
twiniest1147153twiniest
twining113211443twining
twinkies1535983twinkies
twinkle1464773twinkle
twinkles1535073twinkles
twinkly1733913twinkly
twins85118983tw__ins
twirl85011943twi_rl_
twirly12427083twi_rly
twirps11415013twi_rps
twists9549753twi_sts
twits86015793tw__its
tymbals14265723tymbals
vigils104210193_vigils
wails86631483_w_ails
wilily123310763_wilily
wills84528963_wi_lls
wirily123310783_wirily

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.403443402.0
2DLD Change Limit134027975.65623696.4
3Display Results97970.0332939.4
 (SQL Overall)178691976.09229332.1
 
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.