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

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

129 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
hotelier113763(None) 
homelier1338981homelier
hoteliers1245801hoteliers
atelier7311622_atelier
comelier12310652comelier
holier94921622ho__lier
hosteler1137282hostel_er
hosteller1245862hosteller
hotelmen1344192hotelmen
lonelier838002lonelier
lovelier1136432lovelier
motlier92010582mot_lier
ateliers837883_ateliers
belier84423563__belier
botchier15287143botchier
botflies1336733botflies
bottler94211883bottl_er
coalier93416183co_alier
collier93618153co_llier
complier14310253complier
costlier1038523costlier
coterie9417403coterie_
coteries10422703coteries
cottier93814173cot_tier
cutesier1045623cutesier
dotier73917033dot__ier
dottier83910923dot_tier
eelier64216463__eelier
gaselier946963gaselier
ghostlier1343343ghostlier
godlier938893go_dlier
gogglier1153923gogglier
goodlier1035793goodlier
hacklier1737133hacklier
haulier1059943h_aulier
heeler93917313h_eel_er
heller93322513h__eller
helper114313093h__elper
hillier103413963h_illier
hoarier104211743ho_arier
hobbler143710403hobbl_er
hoelike141411163ho_elike
hokier134214033ho__kier
holder104619653ho__lder
holies94630033ho__lies
holler93520613ho__ller
hollies103420813ho_llies
homeliest1448553homeliest
homelike17179533homelike
homier116416993ho__mier
homilies132710113homilies
honester1139713honester
hoodier113812973ho_odier
hookier143811673ho_okier
hoolie93217783ho_olie_
hootier104915353ho_otier
hoppier143110703ho_ppier
hornier103012463ho_rnier
horsier103013243ho_rsier
hoselike15179643hoselike
hosier94219613ho__sier
hosteled1237293hostel_ed
hostelers1246643hostel_ers
hosteling1337893hosteling
hostelled1345733hostelled
hostellers1344683hostellers
hostelries1345423hostelries
hostler103411023hostl_er
hotel85520753hotel___
hoteldom1463383hoteldom
hotelman1344103hotelman
hotels94515523hotel__s
hotline10712353hot_line
hotlines11811643hot_lines
hotlink1476763hot_link
hotter94720083hot__ter
hottie92514383hot_tie_
hotties103016963hot_ties
hourlies1138343hourlies
hoveled14209293hovel_ed
hoveling15189593hoveling
hovelled15146843hovelled
hoverer13319823hove_rer
however1634513howe_ver
howler123514313ho_wl_er
jollier142911003jo_llier
jowlier17327563jo_wlier
likelier1235283likelier
livelier1136873livelier
lordlier935363lordlier
loudlier934953loudlier
lovelies1139893lovelies
lowlier10338903lo_wlier
modeler1039293model_er
modeller1136613modeller
mothier121910213mot_hier
motleyer1343263motleyer
mottler94410343mottl_er
nettlier864813nettlier
notifier1137423notifier
novelizer2144703novelizer
oilier64417233_o_ilier
onerier7311613_onerier
outlier72216143_outlier
portlier1038373portlier
pottier93516493pot_tier
relier65826183__relier
roilier7311523ro_ilier
roturier836033roturier
shapelier1444463shapelier
shoalier1137073sho_alier
shoveler14165583shovel_er
shoveller15174543shoveller
sommelier1343643sommelier
statelier945653statelier
steelier839193steelier
telfer9379893__telfer
teller63519823__teller
timelier1036713timelier
totalizer1847993totalizer
towerier1137123towerier
waterier11312083waterier
wifelier1434853wifelier
wiselier1137363wiselier
wobblier15325203wobblier
woolier103612353wo_olier
woollier1155433woollier
yodeler1136343yodel_er
yodeller1244853yodeller

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 Filter1786911461620.420425454.8
2DLD Change Limit1461621297.34319904.9
3Display Results1291290.0502580.0
 (SQL Overall)1786911297.81322871.0
 
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.