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

127 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
poetizer193681(None) 
poetiser1037311poetiser
poetize18310771poetize_
poetized2037971poetized
poetizers2045101poetizers
poetizes19310251poetizes
appetizer2244432appetizer
peptizer21236472peptizer
poetise9314042poetise_
poetised1138522poetised
poetisers1145302poetisers
poetises10313952poetises
pottier93516492potti_er
potzer174411202po_t_zer
poutier93215322pouti_er
appetiser1344443appetiser
appetizers2343023appetizers
baptizer2134883baptizer
cognizer2055863cognizer
cottier93814173cotti_er
dotier73917033do_ti_er
dottier83910923dotti_er
footier104115113footi_er
goutier82612353gouti_er
hootier104915343hooti_er
howitzer2341913howitzer
iodizer17408663io_dizer
ionizer162310123io_nizer
itemizer19104453itemizer
joltier14318493jolti_er
loftier1037763lofti_er
metier83517693_meti_er
monetize1949983monetize_
monetized2147153monetized
monetizes2049263monetizes
mortiser1078473mortiser
netizen1635883_netizen
noticer937273no_ticer
novelizer2144703novelizer
palletizer2184363palletizer
partier93520713parti_er
pastier94320383pasti_er
patzer173111643p_at_zer
peatier94017233peati_er
pectize20259913pectize_
pectized22257583pectized
pectizes21229783pectizes
pelletizer2144183pelletizer
peptize20279483peptize_
peptized22237503peptized
peptizers22245033peptizers
peptizes21269853peptizes
pestier94317403pesti_er
peter74427593p_et__er
petite84320653p_etite_
petites93820203p_etites
petter83924773p_et_ter
pettier94213613p_ettier
pieties9419223pieti_es
pitier84019823p_iti_er
platier93716293plati_er
plottier10327263plotti_er
pockier153911603pocki_er
podgier11338723podgi_er
poesies93217403poesi_es
poetaster1145673poetaster
poetic10416843poeti__c
poetical12311533poetical
poeticize2247513poeticize_
poeticized2445773poeticized
poeticizes2347123poeticizes
poetics11312073poeti_cs
poetizing2148683poetizing
poetlike1436733poetlike_
poetries10315583poetries
pointier1038303pointi_er
poiser84217243po__iser
pokier124914633po_ki_er
polarizer2079173polarizer
polemize2148673polemize_
polemized2346493polemized
polemizes2248143polemizes
policer113112683po_licer
politer92417073po_liter
pollenizer2144583pollenizer
pontifex2043253pontifex
pontine92419053pontine_
porkier133712343porki_er
pornier93413123porni_er
porter84224413port__er
portiere1038773porti_ere
portioner1158683portioner
portlier1038373portlier
positiver1445483positiver
poster84129173post__er
postie84123963posti_e_
posties93128813posti_es
postrider1246643postrider
posturer1038923posturer
pother113818853po_t_her
potter83926983po_t_ter
potterer102310263potterer
potties93723543potti_es
potzers184010543po_t_zers
pouter83923983pout__er
poutine93316823poutine_
poutines102415103poutines
powter114116033powt__er
poxier153812113po_xi_er
preciser123411663preciser
premier113515633premi_er
presider11410423presider
prettier1069043prettier
pretzel1835143pret_zel
prizer174714883p__rizer
purtier93214093purti_er
puttier93314503putti_er
retirer74715013_retirer
rootier74915393rooti_er
rotifer1036993ro_tifer
seizer154114573_se_izer
sootier73916603sooti_er
sportier102010053sporti_er
spottier10207303spotti_er
unitizer1746203unitizer
vetiver1336103_vetiver
zootier163611173zooti_er

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.296603685.8
2DLD Change Limit1461621277.06320694.0
3Display Results1271270.0462760.9
 (SQL Overall)1786911277.40524131.1
 
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.