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

(Found more than 100 similar words, so Change Limit cannot be increased.)
to automatically search another random word after seconds.

124 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
ichs9621471(None) 
ices66129641ices
ich86227741ich_
aahs716428562aahs
aces67645092aces
ache96829822ache
aches106132292aches
achy126316092achy
acts66929862acts
ahs68644822_ahs
bices95029962bices
chi86228652_chi
chis95933312_chis
cigs75625102cigs
cis57748032_cis
cos510270392_cos
dahs88231812dahs
dices86434242dices
dicks125824692dicks
eche97520282eche
eches106322162eches
echo96615952echo
echos105216462echos
echt95722902echt
ecus65421462ecus
edhs86212102edhs
eths76619522eths
fehs106522382fehs
fices106031162fices
fiche134616742fiche
fiches145219532fiches
fichu134810662fichu
fichus14388112fichus
ficus105015492ficus
hahs108333362hahs
hehs106723962hehs
hicks145322172hicks
highs125412522highs
ibis66519582ibis
ice56737242ic_e
iced78721892iced
ichor1039482ichor
ichors11310422ichors
ick97329322ic_k
icky136315752icky
icon66922042icon
icons76516492icons
ictus7249702ictus
icy86322122ic_y
ides57734232ides
ids47535462i_ds
ifs67124242i_fs
iggs66612672iggs
ilks87218572ilks
ills47030422ills
imps86221122imps
inch95420822inch_
inches114419672inches
incus73315052incus
inks86926502inks
inns46920932inns
ins35945602i_ns
ions46737852ions
ires45639282ires
iris45732552iris
irks86220132irks
is27048212i__s
isms66213472isms
itch95619172itch_
itches114916212itches
itchy13449012itchy
its35538832i_ts
iwis77117012iwis
kicks104420082kicks
kiths125814972kiths
laichs115110892laichs
lich96230842lich_
liches114724292liches
lichi104412952lichi
lichis115212592lichis
licht104723492licht
lichts113712382lichts
licks115325392licks
lochs106715512lochs
machs125722562machs
micas96823052micas
miche126219242miche
miches134320732miches
micks135525372micks
mics87435152mic_s
niche105016792niche
niches114419142niches
nicks114920492nicks
nighs95013612nighs
ocas66729632ocas
ohs66232312_ohs
oohs75220692oohs
pechs125516202pechs
pehs95625762pehs
picas94626522picas
picks135226142picks
pics85633912pic_s
piths105817542piths
rices75536152rices
rich97025542rich_
riches115022082riches
ricks115126132ricks
sices75637272sices
sicks115127622sicks
sics65234092sic_s
sighs95416742sighs
sinhs86719602sinhs
stichs114511652stichs
tachs105820932tachs
techs106915832techs
ticks115823292ticks
tics65729632tic_s
ughs85410972ughs
vices105725532vices
vichy1639042vichy
wich125724742wich_
wiches144418752wiches
wicks144619362wicks
yechs136112582yechs

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.283631417.0
2DLD Change Limit298721240.85634897.2
3Display Results1241240.0333757.6
 (SQL Overall)1786911241.172152466.7
 
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.