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

84 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
postiche154779(None) 
pastiche1546931pastiche
postiches1648221postiches
potiche1438041po_tiche
mastiche1547172mastiche
pastiches1637452pastiches
pistache1545892pistache
postie84123962posti__e
postique1945872postique
potiches1539202po_tiches
apostille1144243apostille
corniche1575923corniche
costive12312843costi_ve
distich13312173distich_
distichs1447633distichs
hospice14117063hospic_e
hostile10312553hosti_le
justice1637423justic_e
mastiches1647333mastiches
mortice11711493mortic_e
moustache1663083moustache
mustache15185283mustache
notice8313443no_tic_e
ossicle944483_ossicle
ostiole739013_ostiole
ostrich1238663_ostrich_
ostriches1446633_ostriches
particle1239533particle
pasticci1443823pasticci
pasticheur1751743pasticheur
pastie85525523pasti__e
pastille1038943pastille
pastime114611973pasti_me
pesticide1447283pesticide
pistaches1646673pistaches
poetic10416843poetic__
poetical12311533poetical
poeticize2247523poeticize
poetics11312073poetic_s
poetise9314043poeti_se
poetize18310773poeti_ze
police102918563po_lic_e
pontine92419053ponti_ne
popsicle1443653popsicle
portico11310143portic_o
porticoed1445423porticoed
porticoes1348253porticoes
porticos1238373porticos
portiere1038773portiere
positive1349993positive
possible1245813possible
postage103214853post_age
postbase1246443postbase
postcode1346323postcode
postdate1139653postdate
postdive1445763postdive
postface1566123postface
postfire1346273postfire
postgame1345523postgame
posthole1339533posthole
posties93128813posti_es
postin83521033posti__n
posting105622243posti_ng
postings112912303postings
postins93721203posti_ns
postiques2045833postiques
postlude1144543postlude
postpone1248693postpone
postpose1247653postpose
postrace12310543postrace
posture9313253post_ure
potlache15114283potlache
potsie83916033potsi__e
poultice1246063poultic_e
poutine93316823pouti_ne
prostie91617743prosti__e
psyche1674293p_s_yche
rotche114311983ro_t_che
seiche11811833__seiche
solstice1047223solstic_e
soutache1344983soutache
stich104117923__stich_
stichs114511653__stichs
testicle1037443testicle

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.420425454.8
2DLD Change Limit146162846.92321112.5
3Display Results84840.0302800.0
 (SQL Overall)178691847.37324235.9
 
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.