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

67 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
harelip124595(None) 
harelips1345211harelips
harelike1539612harelike
abelia83114403_abelia
areic73219393_are_ic
atelic8313703_atelic
barefit1249723barefit
barely114716793barel_y
camelia11510433camelia
camelid1249413camelid
capelin11510973capelin
carlin84421823car_lin
caroli85918233caroli_
charlie123011923char_lie
earflap1243273earflap
earlap837183ear_lap
firelit10310863firelit
garlic9310043gar_lic
haemic133210083ha_emic
haemin113412663ha_emin
halid94424983ha__lid
hamuli1137063hamuli_
hardily143310273hardily
hardline12310273hardline
hardly135112833hardl_y
hardship1746033hardship
hardtop1345053hardtop
hare76255733hare___
hared95742183hare__d
hareem114312063hare_em
hareems12428203hareems
harem104924453hare__m
harems115513823hare_ms
hares86255543hare__s
harl75740003har_l__
harlot94422803har_lot
harls85634503har_l_s
harmin113117393har_min
harp96134283har___p
harpin113614383har_pin
harslet10315653harslet
hazel176414813hazel__
hazelly2254383hazelly
hazels185710083hazel_s
helio85321193h__elio
helix154413013h__elix
help95328923h__el_p
herein93717793here_in
heretic12314833heretic
hireling121210993hireling
javelin17306983javelin
marlin84220903mar_lin
paresis93315093paresis
paretic113016673paretic
parhelia1346713parhelia
parhelic1547093parhelic
parsnip1146323parsnip
prelim10311423_prelim
rarebit948423rarebit
rarely93513653rarel_y
rareripe1045113rareripe
ravelin102211023ravelin
redip87816963__redip
relic74623363__relic
relit55340683__relit
warship1547833warship
yarely122810303yarel_y

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 Filter1786911340270.1601116818.8
2DLD Change Limit134027677.43618024.1
3Display Results67670.0302233.3
 (SQL Overall)178691677.62623431.8
 
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.