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

(Change Limit cannot be increased to the length of your word, because then every letter could be different!)
to automatically increase the Change Limit after seconds.

99 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
whiz19591994(None) 
phiz186718841phiz
whid115418871whid
whig115516421whig
whim126220521whim
whin105225691whin
whip125521841whip
whir105519281whir
whit104834171whit
whizz194210321whizz
wiz156434151w_iz
ahi68040232ahi_
ahis76135382ahis
biz147939362_biz
chez184519022chez
chi86228652chi_
chia96026622chia
chic115925202chic
chid106626402chid
chin96934742chin
chip116726422chip
chis95933312chis
chit96937462chit
fiz156238762_fiz
friz166324342friz
ghi77019882ghi_
ghis85020162ghis
hi57947582_hi_
hic86540562_hic
hid76248362_hid
hie67652702_hie
him86247652_him
hin67559562_hin
hip86750432_hip
his66359502_his
hit66569192_hit
khi106318302khi_
khis117017982khis
ohia75719362ohia
phi86524202phi_
phis95724902phis
quiz224920002quiz
shim95827842shim
shin75634302shin
ship95228232ship
shit76745932shit
shiv105721162shiv
thin76732382thin
thio77225412thio
thir76420542thir
this76027382this
waif105836752waif
wail75238822wail
wain75840192wain
wair75830052wair
wait75553692wait
weir76019922weir
wha96422072wh_a
wham125321692wham
whap125119642whap
what105434072what
whee105429592whee
when105723042when
whet105133782whet
whew137618782whew
whey135018712whey
which163910082which
whids125413982whids
whiff17310062whiff
whigs125612642whigs
while115418692while
whims134515332whims
whine116022812whine
whins114922332whins
whiny144915572whiny
whips134917082whips
whipt135317422whipt
whirl114913822whirl
whirr114611192whirr
whirs115218092whirs
whish144512922whish
whisk154510142whisk
whist115322952whist
white114920302white
whits115923822whits
whity145513472whity
whizzy23274072whizzy
who95526772wh_o
whoa106615202whoa
whom127018172whom
whop125520922whop
whup125714162whup
why126920012wh_y
whys137011662whys
wig76740382w_ig
win66456292w_in
wis66552332w_is
wit66563772w_it
writ75537912writ

Search took 2 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 Filter178691298720.0632836365.1
2DLD Change Limit29872990.90632971.3
3Display Results99990.0303300.0
 (SQL Overall)178691990.999178869.9
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2024  |  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.