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

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

90 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
poetisers114530(None) 
poetiser1037311poetiser_
poetises10313951poetise_s
poetizers2045101poetizers
appetisers1442932appetisers
mortisers1186162mortisers
poetasters1245282poetasters
poetise9314042poetise__
poetised1138522poetise_d
poetizer1936812poetizer_
poetizes19310252poetize_s
poisers94214432po__isers
appetiser1344443appetiser_
appetizers2343023appetizers
betises94816123_betise_s
cottiers10399153cotti_ers
devisers12339863_devisers
foetuses1136083foetuse_s
metiers93312843_meti_ers
monetises11311043monetise_s
mortiser1078473mortiser_
mortises10713613mortise_s
noesises838503noesise_s
noticers1035693no_ticers
partiers103514243parti_ers
pastises103616053pastise_s
pavisers13387443p_avisers
peises84125043p_e_ise_s
penises9318193p_enise_s
peptizers22245033peptizers
perusers10328803p_erusers
peters86624593p_et__ers
petites93820203p_etite_s
petters93722363p_et_ters
pieties9419223pieti_e_s
pietisms1247463pietis_ms
pietists1038323pietis_ts
pitiers93812653p_iti_ers
pleasers104010293ple_asers
poesies93217403poesi_e_s
poetaster1145673poetaster_
poetess938933poet__ess
poetesses1137233poetesses
poetics11312073poeti__cs
poetising1238713poetising
poetize18310773poetize__
poetized2037983poetize_d
poetless1038723poet_less
poetries10315583poetrie_s
poiser84217243po__iser_
poises84226543po__ise_s
policers12259993po_licers
polishers1477603po_lishers
porters93722703port__ers
portiere1038773porti_ere
portieres1138213porti_eres
portioners1257413portioners
posers84223973po___sers
posters93928013post__ers
posties93128813posti_e_s
postriders1344853postriders
posturers1137053posturers
pothers123818623po_t_hers
potsies93019483po_tsie_s
potterers11218663potterers
potters94024343po_t_ters
pottier93516493potti_er_
potties93723543potti_e_s
pottiness1179703pottiness
potzers184010543po_t_zers
pouters94221873pout__ers
poutier93215323pouti_er_
poutines102415103poutine_s
powters124015663powt__ers
praisers103410833p_raisers
preciser123411663preciser_
precises123218333precise_s
premiers122911653premi_ers
premises123018273premise_s
presiders1248213presiders
pressers103215023pre_ssers
previses133814283previse_s
previsors14126483previsors
promisers13268203promisers
puttiers10288013putti_ers
retirers84311533_retirers
revisers113511933_revisers
rotifers1136043ro_tifers
seisers73816393_se_isers
vetivers1435163_vetivers

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 Filter1786911486410.436409841.7
2DLD Change Limit148641907.04621095.8
3Display Results90900.0461956.5
 (SQL Overall)178691907.52823736.8
 
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.