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

78 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
poblano114509(None) 
poblanos1244991poblanos
pompano1345202pompano
solano65314182so_lano
beano75421553__beano
bland85320453__bland
blank115418553__blank
coolant9316463coolant
dobla84913643dobla__
doblas93812293dobla_s
doblon938013doblon_
doblons1037043doblons
goban84414073gob_an_
gobang10376703gob_ang
gobans94412043gob_ans
goblin939503goblin_
goblins1039243goblins
holland11349473holland
llano5910603__llano
lowland1134693lowland
norland837163norland
oblast8613663_oblast
oblate82214743_oblate
oblong935383_oblong
paesano9338793paesano
paisano9429513paisano
parlando1145413parlando
phalanx1945203phalanx
piano76118713p__iano
pintano998993pintano
plan65833943p__lan_
plane74929143p__lane
plank115221143p__lank
plans75731273p__lans
plant75437113p__lant
plowland1442743plowland
polar75623453po_la_r
polaron939843po_laron
polars84419353po_lars
poling93526503po_ling
polio75722553po_l_io
pollack1567333pollack
pollard103511143pollard
pollen83416453pollen_
pollens93713303pollens
polling102920383polling
polo66236633po_l__o
pompanos1445243pompanos
pooling103219093pooling
poplar103611113popla_r
poplars113910333poplars
poplin10413483poplin_
poplins11313153poplins
porcino1138113porcino
porno75120653po__rno
potato8513433po_tato
potlach14106363potlach
potline91015233potline
potman102813573potman_
poulard10299733poulard
proband122710243prob_and
probang12278383prob_ang
prolan8414693prolan_
prolans9314273prolans
robalo838933rob_alo
roband92310723rob_and
romano84912943ro_mano
solan55328153so_lan_
soland75115043so_land
solanos74412853so_lanos
solans64122493so_lans
soprano937003soprano
tolan55124013to_lan_
tolane64316583to_lane
tolans64319273to_lans
volant9316323vo_lant
volcano1244613volcano
zebrano1843853zebrano

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 Limit134027785.95322514.2
3Display Results78780.0302600.0
 (SQL Overall)178691786.38927968.5
 
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.