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

You can choose a higher Change Limit to return more words, although it will take longer.
to automatically increase the Change Limit after seconds.

92 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
hiree8542780(None) 
hire75538961hir_e
hired95226261hired
hirees95117291hirees
hirer85423121hirer
hires86134341hires
siree55238811siree
agree65226032agree
aired66032922aired
airer54927892airer
bireme10310142bireme
birle75023632birle
birse74517402birse
bree67241262_bree
chirre114111852chirre
cire65836372cir_e
cires74932912cires
dire56644142dir_e
direr64927072direr
dirge75117072dirge
dree56638322_dree
fire76245592fir_e
fired94829742fired
firer811229252firer
fires85740752fires
free75940182_free
gree56641562_gree
haired105117172haired
hare76255732har_e
hared95742182hared
hareem114312062hareem
harem104924452harem
hares86255542hares
heired103813042heired
here76447102her_e
heres86245902heres
hide85134642hi_de
hided105222442hided
hider95024082hider
hides95129422hides
hie67652702hi__e
hied85434042hi_ed
hies74842832hi_es
hike116830392hi_ke
hiked135919202hiked
hiker125119392hiker
hikes125426982hikes
hinge95323452hinge
hirers94518062hirers
hirple11158972hirple
hirsel9138682hirsel
hirsle9159572hirsle
hive106029672hi_ve
hived125217912hived
hives116925512hives
horde94623052horde
horse86132652horse
ire36943172_ir_e
ired55131872_ired
ires45639282_ires
laree56036292laree
lire47845292lir_e
mire66748232mir_e
mired85729222mired
mires75640882mires
mirex146816622mirex
pree67044732_pree
puree74632842puree
ree37974072__ree
saree55044662saree
scree720031712scree
shire84727132shir_e
shires95225572shires
sire46150412sir_e
sired66134282sired
sirees64624582sirees
siren54525822siren
sires55945372sires
sirree64017342sirree
soiree62919482soiree
spree74830862spree
three87526912three
tire46143352tir_e
tired65228902tired
tires55437492tires
tree47745812_tree
vireo84816452vireo
vires84529682vires
wire75839812wir_e
wired95327642wired
wirer85124952wirer
wires86034912wires

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 Filter178691538000.310576422.6
2DLD Change Limit53800921.50035866.7
3Display Results92920.0332787.9
 (SQL Overall)178691921.84396956.6
 
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.