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

227 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
unhoused123814(None) 
unhorsed1238831unhorsed
unhouse1038921unhouse_
unhouses1138701unhouses
choused135012462_choused
funhouse1444522funhouse_
funhouses1544592funhouses
housed105624102__housed
rehoused1239612rehoused
unabused1135612unabused
unamused1135782unamused
unaroused1046512unaroused
uncaused1138442uncaused
unfocused1553392unfocused
unfused11319502un_fused
unhooded13277872unhooded
unhooked16286742unhooked
unhoped13249352unho_ped
unhorse1038582unhorse_
unhorses1138452unhorses
unhouseled1442062unhouseled
unhusked1634602unh_usked
unloosed9117522unloosed
unpoised1139172unpoised
unposed10711902unpo_sed
unsoured9310052unsoured
unused72012872un__used
uproused1135832uproused
aroused84914343_aroused
bloused104310643_bloused
boused95322883__boused
bughouse1445073bughouse_
bughouses1544743bughouses
bunkhouse18123653bunkhouse_
bunkhouses19123393bunkhouses
caroused1149253caroused
chorused1446133_chorused
chouse116017563_chouse_
chouser125212943_chouser
chouses125117813_chouses
chowsed16478603_chowsed
deloused1036973deloused
doused84821163__doused
endorsed1057193endorsed
ensouled935833ensouled
enthused1245083enthused
espoused1134853espoused
groused94712833_groused
henhouse1445573henhouse_
henhouses1546173henhouses
hocused13167013__hocused
hoised105117433__hoised
horsed105321083__horsed
hosed95830983__ho_sed
hothoused1644763hothoused
house89131423__house_
housel95217043__housel
houser95322283__houser
houses96032273__houses
incused102911173in_cused
indorsed1066123indorsed
infused11329253in_fused
inhumed1375573inh_umed
inpoured1135813inpoured
insouled936113insouled
knouted12416763kn_outed
loused74822913__loused
moused94423303__moused
noised75416233_n_oised
noosed75018013_n_oosed
nosed65524553_n_o_sed
nouses64627163_n_ouses
nuthouse1145833nuthouse_
nuthouses1246343nuthouses
outhouse11310873outhouse_
outhouses12310653outhouses
rehouse10311773rehouse_
rehouses11312113rehouses
roused75426443__roused
shouted113911543_shouted
snouted84311343sn_outed
soused74822983__soused
spoused10349653_spoused
thoued10429003_thou_ed
toused74122013__toused
unbased103513483un_based
unbemused1442553unbemused
unbiased1147143unbiased
unbobbed1234413unbobbed
unbodied1237263unbodied
unboiled112410373unboiled
unbolted1179323unbolted
unbonded12299763unbonded
unboned103014223unbo_ned
unbooted1188773unbooted
unbound10158393unbou_nd
unbounded1335413unbounded
unbowed132610243unbo_wed
unboxed17249573unbo_xed
unbruised1244753unbruised
unbrushed1544433unbrushed
unbusted11258773un_busted
uncased104216953un_cased
unchoked18257623uncho_ked
unchosen1356283uncho_sen
unclosed111010503unclosed
unclouded1345333unclouded
uncoated11314963uncoated
uncocked17248753uncocked
uncoded11312743unco_ded
uncoiled112512683uncoiled
uncoined111813023uncoined
uncombed1536323uncombed
unconfused1642943unconfused
uncooked15269113uncooked
uncooled112710633uncooled
uncorked152210403uncorked
uncounted1238513uncounted
uncoupled1445703uncoupled
uncrossed1236313uncrossed
uncrushed1545023uncrushed
uncured10513233un_cured
uncursed1148963uncursed
underused1139323underused
undocked16277633undocked
undotted1048523undotted
undoubled1344223undoubled
undoubted1344453undoubted
unerased9312773unerased
unexcused1942473unexcused
unfluted1237173unfluted
unfocussed1642083unfocussed
unfoiled12249723unfoiled
unfolded1338313unfolded
unforced14239133unforced
unforged13238623unforged
unforked16218953unforked
unformed14239573unformed
unfound11127393unfou_nd
unfounded1435363unfounded
unglossed1144133unglossed
unglued937303unglu_ed
ungowned1335183ungowned
ungrouped1343673ungrouped
unhailed12219963unhailed
unhaired12238763unhaired
unhalved1556513unhalved
unhanded132910183unhanded
unhanged13258833unhanged
unharmed1438093unharmed
unhatted1238183unhatted
unhealed121511073unhealed
unheated121514553unheated
unhedged1434963unhedged
unheeded1336893unheeded
unhelmed1435993unhelmed
unhelped1435923unhelped
unhinged13257463unhinged
unhired112512153unh_ired
unholier1137283unholier
unhonored1344413unhonored
unhood1039233unho__od
unhousing1335883unhousing
unhusk1334263unh_us_k
unhusks1443263unh_usks
unionised1046523unionised
unissued934673unissued
unjoined16248443unjoined
unkissed1334883unkissed
unleased9310713unleased
unloaded1049533unloaded
unlobed10219743unlo_bed
unlocked15268383unlocked
unloose797863unloose_
unloosen8125263unloosen
unlooses8127293unlooses
unloved112310533unlo_ved
unmolded1237453unmolded
unmoored1137333unmoored
unmounted1245903unmounted
unmourned1254153unmourned
unmoved13248903unmo_ved
unnoted8311363unno_ted
unoiled82415473un_oiled
unowned1148803un_owned
unpolled1168943unpolled
unposted1159433unposted
unpotted11108393unpotted
unpruned1136863unpruned
unquoted1836533unquoted
unraised91811873unraised
unrinsed938373unrinsed
unroasted1036613unroasted
unrobed102711213unro_bed
unrolled9610413unrolled
unroofed12106773unroofed
unrooted9810513unrooted
unroped102812103unro_ped
unround8138503unrou_nd
unrounded1135863unrounded
unruled8311373un_ruled
unrushed12247573un_rushed
unrusted92310353un_rusted
unsoaked1338853unsoaked
unsoiled92412073unsoiled
unsolved1237833unsolved
unsorted9312513unsorted
unsound8158433unsou_nd
unsounded1135533unsounded
unsourced1244823unsourced
unsowed112511053unso_wed
untouched1544413untouched
untrussed1045533untrussed
untuned82010823un_tuned
unversed122310433unversed
unvoiced14106303unvoiced
unwonted12248643unwonted
unwooded13207443unwooded
unwooed11229773unwo_oed
unworked16238503unworked
unwound11126613unwou_nd
unwounded1444623unwounded
unyoked1567123unyo_ked
unzoned172310653unzo_ned
uprouse937223uprouse_
uprouses1037553uprouses
uptossed1142933uptossed

Search took 9 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.1561145455.1
2DLD Change Limit1461622277.73318901.1
3Display Results2272270.1102063.6
 (SQL Overall)1786912277.99922339.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.