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

96 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
huic9481805(None) 
hic86540561h_ic
humic124113241humic
aulic74420242aulic
auric74521722auric
chic115925202chic
cubic114313412cubic
cuif96529132cuif
duci76422622duci
dui46433382dui_
duit56241582duit
emic86422742emic
epic86921302epic
etic66123952etic
flic96223732flic
fuci95720312fuci
guid66022822guid
haik115526982haik
hail74839062hail
hair76330142hair
heil76328932heil
heir77523802heir
hemic125718622hemic
hi57947582h_i_
hick135530302h_ick
hid76248362h_id
hie67652702h_ie
him86247652h_im
hin67559562h_in
hip86750432h_ip
his66359502h_is
hit66569192h_it
hoick145210682hoick
hub86437482hu_b
hubs96027142hubs
huck135927632huck
hue66642302hu_e
hued86925852hued
hues75235232hues
huff135623842huff
hug76037362hu_g
huge86321652huge
hugs86129752hugs
huh96432012hu_h
hula74923752hula
hulk115321612hulk
hull75428782hull
hum85542932hu_m
humid114213762humid
hump116228722hump
hums96831422hums
hun65844712hu_n
hunch136416212hunch
hung86126352hung
hunh106323732hunh
hunk116029542hunk
huns76136932huns
hunt76445492hunt
hup86437812hu_p
hurl76029932hurl
hurt77142572hurt
hush105224112hush
husk116021952husk
hut66457292hu_t
hutch135414092hutch
huts76737442huts
juice14311322juice
juicy1738282juicy
laic65931562laic
ludic82912802ludic
mic77647632_mic
music94316402music
odic74920572odic
ohmic1237832ohmic
otic66624812otic
pic76046822_pic
pubic114513712pubic
pudic104614562pudic
pyic116915822pyic
quick204311062quick
quid144922352quid
quin135823922quin
quip154818622quip
quit136136512quit
quiz224920002quiz
ruin47430512ruin
runic73615772runic
sic55847872_sic
spic85227432spic
suit45649872suit
tic56343462_tic
tui37034022tui_
tuis44829642tuis
tunic74018222tunic
uric63624932uric
zoic152316072zoic

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.0802233637.5
2DLD Change Limit29872960.89033564.0
3Display Results96960.0166000.0
 (SQL Overall)178691960.986181228.2
 
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.