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

115 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
poultry123538(None) 
country12388042country
paltry114910402p_altry
peltry11288652p_eltry
poetry1139382po_etry
poulard10299732poulard
poult76928872poult__
poulter93712012poulter
poulters103911052poulters
poults84613482poult_s
pouty107018812pou_t_y
psaltry12213802psaltry
sultry938462_sultry
adultery1244223adultery
adultly1143753adultly
bouldery14295013bouldery
bounty113411073bount_y
coquetry2243563coquetry
coulter94115603coulter
coulters103614313coulters
county114313323count_y
courtly1256923courtly
faulty12429363fault_y
foolery1336693foolery
foulard11257283foulard
fouler93614903fouler_
foully1239013foul_ly
foundry1433913foundry
gauntry1154113gauntry
gouty95217363gou_t_y
jolty155713033jo_lt_y
loury85716753lou__ry
mouldy12437413moul_dy
moult74728723moult__
moulted103310313moulted
moulter93812423moulter
moulters103510783moulters
moults84713703moult_s
mouthy14409063mou_thy
outby10411533_ou_tby
outcry1137993_outcry
outlay92711793_outlay
outre53922203_ou_tre
ovulary1344913ovulary
pantry115014103p_antry
pastry114913033p_astry
pedlary13277543pedlary
pedlery13297083pedlery
philtra12103683philtra
philtre12105213philtre
phratry1543743phratry
pillory12247453pillory
podiatry1444353podiatry
pointy114913283point_y
polar75623453po_lar_
polars84419353po_lars
poler74431793po_ler_
polers84225643po_lers
policy133211513po_licy
polity113015863po_lity
pollard103511143pollard
poller83921853poller_
pollers93420023pollers
poly96235153po_l__y
pooler83819843pooler_
poolers94217423poolers
popery134511703po_pery
poplar103611113poplar_
poplars113910333poplars
popular11319563popular_
popularly1663843popularly
portly114713403po_rtly
portray1237483po_rtray
potatory1348413potatory
potsy105815613po__tsy
pottery123011073pottery
potty105621003po__tty
pouchy16538663pou_chy
pouffy17395883pou_ffy
poularde11276573poularde
poulards11288233poulards
poulterer1145423poulterer
poultice1246063poultice
poultries1148453poultries
poultryman1751393poultryman
poultrymen1751673poultrymen
pour611527473pou__r_
pourer84516043pourer_
pourers93513673pourers
pours74623183pou__rs
pout65752553pou_t__
pouted94021393pou_ted
pouter83923983pou_ter
pouters94221873pouters
pouts75530323pou_t_s
poverty1536433poverty
powdery16396123powdery
prudery1335243prudery
psaltery13224733psaltery
puggry13374823p_uggry
puler74826623p_uler_
pulers83820283p_ulers
pulley113713403p_ulley
pulpy124612363p_ul_py
punty106021613p_unt_y
purty105019403p_urt_y
putty104721403p_u_tty
robotry1244173robotry
sweltry1333413sweltry
toiletry1144103toiletry
ultra539363__ultra
upcountry1651403upcountry
vaulty12388443vault_y
volery1237873vo_lery
zoolatry2042863zoolatry

Search took 7 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.406440125.6
2DLD Change Limit1340271156.34321129.9
3Display Results1151150.0303833.3
 (SQL Overall)1786911156.77926359.5
 
Comments and Suggestions welcome: FaceBook ~ UserVoice ~ SQLServerCentral  |  Developed By: Tom Keller Consulting © 2011-2026  |  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.